﻿create table dbo.UserInGroups (
   GroupUserId          nvarchar(10)         collate Chinese_PRC_CI_AS not null,
   GroupId              nvarchar(10)         collate Chinese_PRC_CI_AS null,
   UserId               nvarchar(30)         collate Chinese_PRC_CI_AS null,
   constraint PK_UserInGroup primary key (GroupUserId)
         on "PRIMARY"
)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description', 
   '机构用户ID',
   'user', 'dbo', 'table', 'UserInGroups', 'column', 'GroupUserId'
go

execute sp_addextendedproperty 'MS_Description', 
   '机构ID',
   'user', 'dbo', 'table', 'UserInGroups', 'column', 'GroupId'
go

execute sp_addextendedproperty 'MS_Description', 
   '用户ID',
   'user', 'dbo', 'table', 'UserInGroups', 'column', 'UserId'
go